<?php
			$day =& $db->query("SELECT DATE_ADD( current_date( ) , INTERVAL 1 DAY )");
			$row =& array_shift($day->fetchRow());			//今日の日付を格納
			$date =& $db->query("select current_Date() - INTERVAL 1 month AS PREV_1month");
			$row2 =& array_shift($date->fetchRow());		//今日の日付から一ヶ月前の日付を格納
			$sql = "select * from volunteer_information where updata_date between '".$row2."' and '".$row."' order by updata_date desc ";

			$res =& $db->query($sql);
			if (PEAR::isError($res)) {			//SQLの実行に失敗すればここでエラー文を出力
				die($res->getDebugInfo());
			}


				print("
					<font color='0e00b0' font size=5><i>新着情報</i></font><hr size=5 width=520 color='#0e00b0' align='left'/>
					<div class='news'
					style='border:thick solid #0080ff 0.;width:520;height:150;overflow:auto;
					scrollbar-3dlight-color:#000000;
					scrollbar-arrow-color:#000000;
					scrollbar-shadow-color:#000000;
					scrollbar-highlight-color:#ffffff;
					scrollbar-track-color:#ffffff;
					scrollbar-darkshadow-color:#ffffff;
					scrollbar-face-color:#ffffff;
					'>
					<Table border='0' width='500' height='150' cellspacing='0'>
					<Tr width=10>
				");
			while ($news =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {	//SQLの実行結果を表示

					$new01 = $news['updata_date'];
					$new02 = $news['volunteer_name'];
					$new03 = $news['pref'];
				echo "<td width=10>";
				echo "<td width=150>$new01</td>";
				echo "<td width=250><a href='volunteer_function/display_volunteer_information.php?volunteer_information_id=".$news['volunteer_information_id']."' >".$new02."</a></td>";
				echo "<td>$new03</td>";
				echo "</tr>";
			}
				echo "</table>";
				echo "</div>";
